package com.foreknow.elm.dao;

import com.foreknow.elm.po.DeliveryAddress;

import java.sql.SQLException;
import java.util.List;

public interface DeliveryAddressDao {
    //根据用户编号查询所属送货地址
    public List<DeliveryAddress> queryById(String userId) throws SQLException;
    //根据送货地址编号查询送货地址
    public DeliveryAddress queryDABbId(Integer daId) throws SQLException;
    //向送货地址表中添加一条记录
    public int insert(String contactName,Integer contactSex,String contactTel,String address,String userId) throws SQLException;
    //根据送货地址编号更新送货地址信息
    public int update(DeliveryAddress deliveryAddress) throws SQLException;
    //根据送货地址编号删除一条记录
    public int delete(Integer daId) throws SQLException;
}
